﻿
<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['memberschange']=array (
  'columns' =>
  array (
    'id' =>
    array (
      'type' => 'number',
      'extra' => 'auto_increment',
      'pkey' => true,
      'label' => app::get('b2c')->_('会员变更记录表id'),
    ),
    
    'member_id' =>
    array (
      'type' => 'number',
      'label' => app::get('b2c')->_('会员id'),
    ),
    
      'state' =>
    array (
      'type' =>
      array (
        0 => app::get('b2c')->_('待处理'),
        1 => app::get('b2c')->_('已处理'),
      ),
      'default' => '0',
      'required' => true,
      'label' => app::get('b2c')->_('处理状态'),
      'width' => 110,
      'filterdefault' => true,
      'editable' => true,
      'filtertype' => 'yes',
      'in_list' => true,
      'default_in_list' => true,
	  'order' => 20,
    ),
    
    
    'changetime' =>
    array (
      'label' => app::get('b2c')->_('资料更改时间'),
      'width' => 75,
      'type' => 'time',
      'editable' => false,
      'filtertype' => 'time',
      'filterdefault' => true,
      'in_list' => true,
      //'default_in_list' => true,
	  'order' => 10,
      //'orderby' => true,//这里加排序
    ),
     'prefrname' => 
     array (
			'type' => 'varchar(55)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('修改前法人姓名'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 30,
            ), 
     'frname' => 
     array (
			'type' => 'varchar(55)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('法人姓名'),
			'in_list' => true,
			'default_in_list' => true,
	        'order' => 35,
            ),  		
      		
     'pregcname' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('修改前公司名'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 40,
            ),         
     'gcname' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('公司名'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 45,
            ),  			
  	'presalesman' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('修改前推荐业务员'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 50,
              ), 
    'salesman' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('推荐业务员'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 55,
              ),  
     		
     'preidnumber' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('修改前法人身份证号'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 60,
            ),  		
     'idnumber' => 
     array (
			'type' => 'varchar(50)',
			'searchtype' => 'has',
			'editable' => true,
			'label' => app :: get('b2c')->_('法人身份证号'),
			'in_list' => true,
			'default_in_list' => true,
			'order' => 65,
            ), 			
	  'pretel' =>
			array (
			  'type' => 'varchar(50)',
			  'label' => app::get('b2c')->_('修改前联系电话'),
			  'width' => 110,
			  'editable' => true,
			  'filtertype' => 'normal',
			  'filterdefault' => 'true',
			  'in_list' => true,
			  'default_in_list' => true,
			  'order' => 70,
			  ), 
      'tel' =>
			array (
			  'type' => 'varchar(50)',
			  'label' => app::get('b2c')->_('联系电话'),
			  'width' => 110,
			  'editable' => true,
			  'filtertype' => 'normal',
			  'filterdefault' => 'true',
			  'in_list' => true,
			  'default_in_list' => true,
			  'order' => 75,
			  ), 
  ),
  
  'engine' => 'innodb',
  'version' => '$Rev: 42798 $',
  'comment' => app::get('b2c')->_('会员信息更改记录表'),
);
